package com.bgIntlgn.client.entity.manufacture.picLibrary;

import yuhuibear.poat.annotations.relation.View;
import yuhuibear.poat.object.bean.Bean;

/**
 * 
 * 厂长级的,表示计划不要的(已经完成的减去计划需要的)
 * 
 * @author Simon Chen
 * 
 */
@View(name = "plan_not_need", sqlToCreate = "select distinct pi.uid as uid "
		+ "from production_plans as pp, production_iterms as pi "
		+ "where pp.id = pi.plan_id and pp.state = 3 "
		+ "and pi.uid not in (select uid from plan_need);")
public class PlanNotNeed implements Bean {

	private String uid;

	public String getUid() {
		return uid;
	}

	public void setUid(String uid) {
		this.uid = uid;
	}
}
